﻿<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="TodosPalpites.aspx.vb" Inherits="BolaoF1_2.TodosPalpites" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        Todos os palpites do GP<br />
        <asp:GridView ID="GridView1" runat="server" AllowSorting="True" 
            AutoGenerateColumns="False" DataSourceID="Palpites">
            <Columns>
                <asp:BoundField DataField="Login" HeaderText="Login" SortExpression="Login" />
                <asp:BoundField DataField="Dt" HeaderText="Dt" SortExpression="Dt" />
                <asp:BoundField DataField="P1" HeaderText="P1" SortExpression="P1" />
                <asp:BoundField DataField="P2" HeaderText="P2" SortExpression="P2" />
                <asp:BoundField DataField="P3" HeaderText="P3" SortExpression="P3" />
                <asp:BoundField DataField="P4" HeaderText="P4" SortExpression="P4" />
                <asp:BoundField DataField="P5" HeaderText="P5" SortExpression="P5" />
                <asp:BoundField DataField="P6" HeaderText="P6" SortExpression="P6" />
                <asp:BoundField DataField="P7" HeaderText="P7" SortExpression="P7" />
                <asp:BoundField DataField="P8" HeaderText="P8" SortExpression="P8" />
                <asp:BoundField DataField="Pole" HeaderText="Pole" SortExpression="Pole" />
                <asp:BoundField DataField="Lap" HeaderText="Lap" SortExpression="Lap" />
                <asp:BoundField DataField="Team" HeaderText="Team" SortExpression="Team" />
            </Columns>
        </asp:GridView>
        <asp:AccessDataSource ID="Palpites" runat="server" 
            DataFile="~/App_Data/lada.mdb" 
            SelectCommand="SELECT Usuario.Login, Palpite.Dt, P1.Nome AS P1, P2.Nome AS P2, P3.Nome AS P3, P4.Nome AS P4, P5.Nome AS P5, P6.Nome AS P6, P7.Nome AS P7, P8.Nome AS P8, Pole.Nome AS Pole, Lap.Nome AS Lap, Team.Nome AS Team FROM ((((((((((((Palpite INNER JOIN Piloto P1 ON Palpite.P1 = P1.IdPiloto) INNER JOIN Piloto P2 ON Palpite.P2 = P2.IdPiloto) INNER JOIN Piloto P3 ON Palpite.P3 = P3.IdPiloto) INNER JOIN Piloto P4 ON Palpite.P4 = P4.IdPiloto) INNER JOIN Piloto P5 ON Palpite.P5 = P5.IdPiloto) INNER JOIN Piloto P6 ON Palpite.P6 = P6.IdPiloto) INNER JOIN Piloto P7 ON Palpite.P7 = P7.IdPiloto) INNER JOIN Piloto P8 ON Palpite.P8 = P8.IdPiloto) INNER JOIN Piloto Pole ON Palpite.Pole = Pole.IdPiloto) INNER JOIN Piloto Lap ON Palpite.Lap = Lap.IdPiloto) INNER JOIN Equipe Team ON Palpite.Team = Team.IdEquipe) INNER JOIN Usuario Usuario ON Palpite.IdUsuario = Usuario.IdUsuario) WHERE (Palpite.IdGP = ?)">
            <SelectParameters>
                <asp:QueryStringParameter Name="?" QueryStringField="IdGP" />
            </SelectParameters>
        </asp:AccessDataSource>
    
    </div>
    </form>
</body>
</html>
